--#
--# Make & Populate County table
-- #
begin;
CREATE TABLE "county" (gid serial PRIMARY KEY,
"name"    varchar(24),
"country" varchar(24));
SELECT AddGeometryColumn('','county','the_geom','4326','MULTILINESTRING',2);
commit;


select name, name, centroid(extent(the_geom)) as the_geom
from administrative
where name like '%County%' 
--and admin_leve=''
group by name
order by name
into county

